DTS Insertion Modes

You can set the insertion mode in the step Maintain technical settings. The insertion mode impacts the generated program. If you change this parameter after the program has been generated, you must repeat the program generation step for the insertion tasks again.

WARNING Changing this parameter might lead to worse performance as well as to data loss. Therefore, only change this parameter if you have extensive DTS and SAP knowledge.

DTS supports the insert modes below. For more information, see the ABAP SQL help on the INSERT statement:

  • Mass modify: Calls the MODIFY SQL statement for the whole DTS package.

  • Single insert: Calls the INSERT SQL statement for each record in the DTS package record by record, e.g. if the DTS package has 1,000 records, this mode will execute 1,000 INSERT SQL statements for mass insertion into the database. This calls the INSERT SQL statement for the whole DTS package.

  • Mass insert accepting duplicate keys: Calls the INSERT SQL statement for the whole DTS package. If the insert fails due to existing records, the DTS package is inserted record by record.

  • Single insert with aggregation: Same as the single insert. However, if the operation fails on an already existing record, the record is updated based on the defined aggregation logic.

  • Mass update: Calls the UPDATE SQL statement for the whole DTS package. This mode makes sense for tables with a generated view. See the chapter Generate Views for Update.

  • Priority mass insert: Splits the records in the DTS package into records with priority and records without priority. The priority records are processed with mass modify and non-priority records are processed with mass insert accepting duplicate keys.

Automatic insert mode behaves as described based on the table settings:

Scenario Key or unique index change Non-key change Different target table Priority Delta load No primary key Aggregation rule/function assigned Chosen insert mode
Migration         X X   Mass insert
Migration         X     Mass modify
Migration/Conversion X     X       Priority mass insert
Migration/Conversion X           X Single insert with aggregation
Conversion   X           Mass update
Conversion   X X         Mass modify

If none of the setting combinations matches your table, the following insert modes will be used:

  • Migration scenario: Mass insert

  • Conversion scenario: Mass insert accepting duplicate keys